<%-- 
    Document   : testes
    Created on : May 14, 2011, 11:01:08 PM
    Author     : diogo
--%>

<%@include file="baseImports.jsp"%>
<%@page import="java.sql.ResultSetMetaData"%>
<%@page import="BancoDados.Relatorio"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="BancoDados.ConexaoWeb"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
	<title>Ag&ecirc;ncia G&oacute;is & G&oacute;is</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="-1">
<!--BEGIN OF TERMS OF USE. DO NOT EDIT OR DELETE THESE LINES. IF YOU EDIT OR DELETE THESE LINES AN ALERT MESSAGE MAY APPEAR WHEN TEMPLATE WILL BE ONLINE-->
<style>#free-flash-header a,#free-flash-header a:hover {color:#c2cae0;}#free-flash-header a:hover {text-decoration:none}</style>
<!--END OF TERMS OF USE-->
	<meta http-equiv="imagetoolbar" content="no" />

<!AJAX>
<%--
--%>
<script src="js/AjaxConnection.js" type="text/javascript"></script>
<script src="js/jQuery.js" type="text/javascript"></script>
<!FLASH>
<script src="flash/jscripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script src="flash/jscripts/AC_ActiveX.js" type="text/javascript"></script>
<!--[if lt IE 7]>
  <link rel="stylesheet" type="text/css" href="css/stylesheetie6.css" />
<![endif]-->

<%--
<script type="text/javascript" src="js/jquery-1.4.3.min.js"></script>
--%>
<link rel="stylesheet" type="text/css" href="css/stylesheet.css">

</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
	<div id="holder">
	<!--BEGIN OF TERMS OF USE. DO NOT EDIT OR DELETE THESE LINES. IF YOU EDIT OR DELETE THESE LINES AN ALERT MESSAGE MAY APPEAR WHEN TEMPLATE WILL BE ONLINE-->
	<div id="copy" style="height: 75px; position: absolute; bottom: 0px; left:0px; border: none; width: 100%;">
		<div id="free-flash-header" style="width:820px;margin:0 auto;text-align:right;position:relative;bottom:0px;margin-top:63px;color:#C2CAE0;font-size:10px;font-family:Verdana">Copyrights - Equipe 1</div>
	</div>
	<!--END OF TERMS OF USE-->
<table width="100%" cellspacing="0" cellpadding="0" style="margin-top:20px; ">
  <tr>
    <td align="center" valign="middle">
		<table width="850" border="0" cellspacing="0" cellpadding="0" style="border-top: 10px #c8efff solid;">

				<tr>
					<td  style="font-family:arial;font-size:8px;">
						<a href="javascript:void(0);" ><img onmousedown="window.location='index.jsp'" onclick="window.location='index.jsp'" src="flash/header_image_1.png" alt=""/></a>
						<!-- Flash Intro Header -->
						<script type="text/javascript">
							//AC_FL_RunContent( 'codebase','http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0','width','850','height','165','src','flash/header','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','flash/header','flashvars','xml_filename=header.xml&header_image_1=header_image_1.jpg&text_sup_y=50&text_inf_y=10' ); //end AC code
						</script>
						<noscript>free template</noscript>																																																																																																																																																																																																																																	<div id="resol"><h1>flash template</h1> <h2>Optimizado para 1024 x 768&nbsp;&nbsp;&nbsp;</h2> <a href="http://www.layouts-templates.com/free-flash-template.htm">flash template</a></div>
					</td>
				</tr>



	<%@include file="consultas/dadosUsuario.jsp"%>
	<%-- <script src="js/datepickercontrol.js" type="text/javascript"></script> --%>
	
    <tr>
        <td width="100%">
            <table width="850"  border="0" cellspacing="0" cellpadding="0">
                <tr>
                    <%@include file="staticHtml/MenuEsquerdo.jsp"%>
                    <td   style="background-color:#edfaff;">
                        <table width="548"  border="0" cellspacing="0" >
                            <tr>
                                <td width="100%" style="padding:30px" align="left">
                                    <br>
									<%--
                                    <table  border="0" cellspacing="0" width="100%">
                                        <tr>
                                            <td valign="top" >
                                                <div align="justify">
                                                </div>
                                                <%
														String sProfissao = request.getParameter("profissao");
														String sProfissional = request.getParameter("profissional");

														if (sProfissao == null) {
															sProfissao = "";
														}
														if (sProfissional == null) {
															sProfissional = "";
														}

                                                %>

                                                <br/> filtrar:
                                                <form action="testes.jsp" >
                                                    <table>
                                                        <tr>
                                                            <td><span> Nome da profiss&atilde;o:</span></td>
                                                            <td><input value="<%=sProfissao%>" name="profissao"/></td>
                                                        </tr>
                                                        <tr>
                                                            <td><span> Nome do profissional:</span></td>
                                                            <td><input value="<%=sProfissional%>" name ="profissional"/></td>
                                                        </tr>

                                                    </table>
                                                    <button type="submit"> buscar </button>
                                                </form>
                                                <% if (!sProfissional.equals("") || !sProfissao.equals("")) {%>
																			Resultado da pesquisa por Profiss&atilde;o "<%=sProfissao%>" e Profissional "<%= sProfissional%>"
                                                <% }%>
                                                <br/>
                                                <%

														ResultSet rs = Relatorio.AreaQuantidade(sProfissao, sProfissional);

														ResultSetMetaData rsmd = rs.getMetaData();

														int iColumnAmount = 0;
                                                %>


												<%@include file="staticHtml/table.html" %>

												<%

														// NOME DAS COLUNA
														iColumnAmount = rsmd.getColumnCount();
														for (int x = 0; x < iColumnAmount; x++) {
															//;
												%>
												<%@include file="staticHtml/td.html" %><b><%= rsmd.getColumnName(x + 1)%></b></td>

											<%
													}
											%>
                                        </tr>


                                        <%
												while (rs.next()) {
                                        %>
                                        <%@include file="staticHtml/tr.html" %>
										<%
																							for (int x = 0; x < iColumnAmount; x++) {

																								String result = rs.getObject(x + 1).toString();
										%>
										<%@include file="staticHtml/td2.html" %> <%= result%> </td>
									<%
																						}
									%>
							</tr>

							<%
									}
							%>
						</table>
							--%>
							
<script type="text/javascript" src="js/fancybox/jquery.fancybox-1.3.4.pack.js"></script>
<link rel="stylesheet" type="text/css" href="css/stylesheet.css">
<link rel="stylesheet" type="text/css" href="js/fancybox/jquery.fancybox-1.3.4.css" media="screen"/>
	<script type="text/javascript">
		$(document).ready(function() {
			$("#various3").fancybox({
				'width'				: '75%',
				'height'			: '75%',
				'autoScale'			: false,
				'transitionIn'		: 'none',
				'transitionOut'		: 'none',
				'type'				: 'iframe'
			});
		});
	</script>
		<%@include file="staticHtml/forms/data.html" %>
		<input id="date2" type="text" tabindex="130" value="1990/05/10" readonly>

		<!COMBO DATA>
		<a href ="javascript:void(0);" >
			<img src="images/scw.gif" onclick="scwShow(scwID('date2'),event);">
		</a>
		<div id="content">

			<ul>
				<li>
					<a id="various3" href="http://www.google.com">Iframe</a>
				</li>

			</ul>
		</div>
				</tr>
			</table>
			<br>
			<br>
			<br>
			<p>&nbsp;</p></td>
	</tr>
</table>


</td>
</tr>
<%@include file="staticHtml/footer.html" %>
